/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */

package reportes;

import java.io.IOException;
import java.io.PrintWriter;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;


import java.io.File;

    import java.sql.Connection;
    import java.sql.DriverManager;
    import java.util.HashMap;
    import java.util.Map;
    import net.sf.jasperreports.engine.*;
    import javax.servlet.ServletOutputStream;

/**
 *
 * @author RVGRFD85
 */
public class test extends HttpServlet {
   
    /** 
     * Processes requests for both HTTP <code>GET</code> and <code>POST</code> methods.
     * @param request servlet request
     * @param response servlet response
     * @throws ServletException if a servlet-specific error occurs
     * @throws IOException if an I/O error occurs
     */
    protected void processRequest(HttpServletRequest request, HttpServletResponse response)
    throws ServletException, IOException {
       response.setContentType("text/html;charset=UTF-8");
        try{
                Connection con=null;
                Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
                //con = DriverManager.getConnection("jdbc:sqlserver://localhost:1433;databaseName=rbh;user=admin;password=admin");
                con = DriverManager.getConnection("jdbc:sqlserver://172.16.1.134:1433;databaseName=RAES;user=RVGRFD85;password=05412345");
                File reportFile = new File(this.getServletContext().getRealPath("testPdf.jasper"));
                Map parameters = new HashMap();
                parameters.put("exp",request.getParameter("value"));
                byte[] bytes = JasperRunManager.runReportToPdf(reportFile.getPath (),parameters,con);
                response.setContentType("application/pdf");
                response.setContentLength(bytes.length);
                ServletOutputStream ouputStream = response.getOutputStream();
                ouputStream.write(bytes, 0, bytes.length);
                ouputStream.flush();
                ouputStream.close();
            }catch(Exception ex){
                PrintWriter out = response.getWriter();
                out.println("<h1>Error en el servidor al crear el documento" + ex.toString() + "</h1>");
            }
    } 

    // <editor-fold defaultstate="collapsed" desc="HttpServlet methods. Click on the + sign on the left to edit the code.">
    /** 
     * Handles the HTTP <code>GET</code> method.
     * @param request servlet request
     * @param response servlet response
     * @throws ServletException if a servlet-specific error occurs
     * @throws IOException if an I/O error occurs
     */
    @Override
    protected void doGet(HttpServletRequest request, HttpServletResponse response)
    throws ServletException, IOException {
        processRequest(request, response);
    } 

    /** 
     * Handles the HTTP <code>POST</code> method.
     * @param request servlet request
     * @param response servlet response
     * @throws ServletException if a servlet-specific error occurs
     * @throws IOException if an I/O error occurs
     */
    @Override
    protected void doPost(HttpServletRequest request, HttpServletResponse response)
    throws ServletException, IOException {
        processRequest(request, response);
    }

    /** 
     * Returns a short description of the servlet.
     * @return a String containing servlet description
     */
    @Override
    public String getServletInfo() {
        return "Short description";
    }// </editor-fold>

}
